<?php
    class product_index_controller extends controllerBase
    {
        public function process()
        {
            $aProducts = $this->database->getListObject('SELECT product.*,images.url AS image_url FROM product LEFT JOIN images ON product.image_id = images.image_id');
            $this->set(array('aProducts' => $aProducts));
        }
    }
?>
